To add a Cross-Tab to an existing report
In this example, a Cross-Tab is added to an existing report to show the sales in North America compared to the rest of the world.
- Open your report.
This example uses the Group by Intervals.rpt included in the Feature Examples directory.
- Click the Design tab.
- On the Insert menu, click Cross-Tab.
Tip:
Another way to do this is to click the Insert Cross-Tab button on the Supplementary toolbar.
The Format Cross-Tab dialog box appears. This dialog box is made up of three tabs: Cross-Tab, Style, and Customize Style.
Defining the structure of the Cross-Tab
Add fields to the Rows, Columns, and Summarized Field areas.
- From the Available Fields list, click Country, then click Add Row.
Tip: You can also add the fields to the different Cross-Tab sections by clicking the field and then dragging and dropping it into either the Columns, Rows, or Summarized Field area.
The Country field is added to the Rows area.
- From the Available Fields list, click Last Year's Sales, then click Add Summarized Field.
The Last Year's Sales field is added to the Summarized Field area.
- Apply additional structure:
- click Country in the Rows area
- click Group Options
- select in specified order from the drop-down list
- type North America for the Name of the Named Group
- click New
- choose is one of from the drop-down list
- select Canada, Mexico, and USA from the drop-down list
- click OK to close the Define Named Group dialog box
- click OK to close the Cross-Tab Group Options dialog box.
Choosing a predefined style
- Click the Style tab.
- Select a style.
Applying a custom style
- Click the Customize Style tab.
- Customize the style as desired.
Finishing the Cross-Tab
- Click OK.
- Place the Cross-Tab in either the Report Header or Report Footer.
- On the Report menu, click Refresh Report Data.
The updated report appears.